From af336a6714083f6c5c227e58b4736bd2a6ccdd27 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 13:53:36 +0000 Subject: [PATCH] Add COMM_IDS.Studied column --- conversion/load_support.sql | 14 ++++++++++---- db/schemas/codes/tables/create/comm_ids.m4 | 1 + doc/src/code_tables.m4 | 15 +++++++++++++++ doc/src/epilog.inc.m4 | 2 ++ 4 files changed, 28 insertions(+), 4 deletions(-) diff --git a/conversion/load_support.sql b/conversion/load_support.sql index 690da8b..56db6e8 100644 --- a/conversion/load_support.sql +++ b/conversion/load_support.sql @@ -76,16 +76,22 @@ INSERT INTO comm_membs_sources (commmembssource, description) GROUP BY source; -- community_lookup -> comm_ids -INSERT INTO comm_ids (commid, name, notes, membcriteria) +INSERT INTO comm_ids (commid, studied, name, notes, membcriteria) SELECT community_lookup.cl_community_id + , CASE + WHEN SUBSTRING(cl_community_id FROM 3 FOR 2) = '_P' THEN + false + ELSE + true + END , community_lookup.cl_community_name , community_lookup.cl_details , '' FROM community_lookup; -- Problem #12 -- hacked here -insert into comm_ids (commid, name, notes, membcriteria) - values ('KL', 'Kalande', '', '') - , ('KL_KK', 'Kasekela/kalande', '', ''); +insert into comm_ids (commid, studied, name, notes, membcriteria) + values ('KL', true, 'Kalande', '', '') + , ('KL_KK', true, 'Kasekela/kalande', '', ''); -- cycle_states INSERT INTO cycle_states (code, asnum, ssrank, description) diff --git a/db/schemas/codes/tables/create/comm_ids.m4 b/db/schemas/codes/tables/create/comm_ids.m4 index 11794ae..0279b73 100644 --- a/db/schemas/codes/tables/create/comm_ids.m4 +++ b/db/schemas/codes/tables/create/comm_ids.m4 @@ -27,6 +27,7 @@ CREATE TABLE comm_ids ( commid TEXT PRIMARY KEY NOT NULL emptytext_check(`CommID') nospaces_check(`CommID') + ,studied BOOLEAN NOT NULL ,name TEXT NOT NULL emptytext_check(`Name') ,notes TEXT NOT NULL diff --git a/doc/src/code_tables.m4 b/doc/src/code_tables.m4 index 5882730..6fba126 100644 --- a/doc/src/code_tables.m4 +++ b/doc/src/code_tables.m4 @@ -249,6 +249,21 @@ CommID (Community IDentifier) |COMM_IDS.CommID_summary| |caseuniquekeycol| +.. _COMM_IDS.Studied: + +Studied +''''''' + +.. |COMM_IDS.Studied_summary| replace:: + A |boolean| value. |true| if the community was ever a study group. + When |true|, individuals cannot be members of the community before + their |BIOGRAPHY_DATA|.\ |BIOGRAPHY_DATA.EntryDate|. + +|COMM_IDS.Studied_summary| + +|notnull| + + .. _COMM_IDS.Name: Name diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4 index b638d26..bf99ea2 100644 --- a/doc/src/epilog.inc.m4 +++ b/doc/src/epilog.inc.m4 @@ -344,6 +344,8 @@ sdb_generated_rst()dnl .. |COMM_IDS| replace:: :ref:`COMM_IDS ` .. |COMM_IDS.CommID| replace:: :ref:`CommID ` +.. |COMM_IDS.Studied| replace:: + :ref:`Studied ` .. |COMM_IDS.Name| replace:: :ref:`Name ` .. |COMM_IDS.Notes| replace:: -- 2.34.1